package com.sdry.mapper.zc;

import com.sdry.model.zc.ZcTrayAndLocationEntity;

/**
 * 上下架管理
 * @ClassName:    ZcUpAndDownMapper   
 * @Description:  
 * @Author:       zc   
 * @CreateDate:   2019年6月2日 下午1:35:20   
 * @Version:      v1.0
 */
public interface ZcUpAndDownMapper {
	/**
	 * 上架前查询库位是否为空
	 * @param zcTrayAndLocationEntity
	 * @return
	 */
	public int countTrayAndLocation(ZcTrayAndLocationEntity zcTrayAndLocationEntity);
	/**
	 * 库位为空上架（新增）
	 * @param zcTrayAndLocationEntity
	 * @return
	 */
	public int bindingTrayAndLocation(ZcTrayAndLocationEntity zcTrayAndLocationEntity);
	/**
	 * 库位不为空上架（追加）
	 * @param zcTrayAndLocationEntity
	 * @return
	 */
	public int addTrayAndLocation(ZcTrayAndLocationEntity zcTrayAndLocationEntity);
	/**
	 * 查询库位中的托盘
	 * @param zcTrayAndLocationEntity
	 * @return
	 */
	public ZcTrayAndLocationEntity selectTrayCodeByLocationCode(ZcTrayAndLocationEntity zcTrayAndLocationEntity);
	/**
	 * 下架
	 * @param zcTrayAndLocationEntity
	 * @return
	 */
	public int unbindTrayAndLocation(ZcTrayAndLocationEntity zcTrayAndLocationEntity);
	/**
	 * 上架前查询物料id
	 * @param tray_code
	 * @return
	 */
	public Long selectMid(String tray_code);
}
